	
/****** Object:  Stored Procedure IDSSortsInsert    Script Date: Sunday, May 13, 2007 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[spIDSSortsInsert]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [spIDSSortsInsert]
GO

	
	

/******************************************************************************
**		File: 
**		Name: spIDSSortsInsert
**		Desc: 
**
**		Return values:
** 
**		Called by:   
**              
**		Parameters:
**		Input							Output
**     ----------							-----------
**
**		Auth: CodeSmith
**		Date: 5/13/2007 4:48:55 PM
*******************************************************************************
**		Change History
*******************************************************************************
**		Date:		Author:				Description:
**		--------		--------				-------------------------------------------
**    
*******************************************************************************/
CREATE PROCEDURE spIDSSortsInsert
	@Name nvarchar(100),
	@SortOrder int,
	@IsDisplayed bit,
	@IDSSortID int output
AS

INSERT INTO [IDSSorts] 
(
	[Name],
	[SortOrder],
	[IsDisplayed]
) 
VALUES 
(
	@Name,
	@SortOrder,
	@IsDisplayed
)

SELECT @IDSSortID = @@IDENTITY

GO
	
